Using the DORIS Connector in Argos
Argos can be used to create a dashboard and report off of Evisions DORIS data.
To use the Evisions DORIS Connector in Argos, create a DataBlock and then select the DORIS Connector data connection in the Associated Connection/Group dropdown.
You can now use the Evisions DORIS Connection in your queries. This could be in the Visual Designer, free type report query, multi-column list boxes, or in any other location where you can use SQL in Argos. Note that all queries against DORIS connections must be accompanied by a snapshot definition.
Snapshot Definition
Snapshot definitions are used by Argos to communicate which DORIS snapshot(s) you would like to include in the result set for your query. Each snapshot definition must include start and end dates, and only the snapshots created within that range will be included. Snapshot definitions also allow you to optionally filter by tags, or keywords that can be attached to DORIS snapshots for identification purposes. Snapshot definitions are a powerful tool which allow you to query current or historical data, depending on what date range you specify for your query.
Evisions DORIS allows you to take a "snapshot" of the data in your data source at a specific date, and save that snapshot for later use. Each snapshot is identified by the creation or census date of when the snapshot was taken. The date range of a snapshot definition controls which DORIS snapshots will be included in the result set. For more information on snapshots, please see the Evisions DORIS in-product help.
The following example shows how a query might look in the Free Type report query editor:
Enter your Free Type query into the text field.
At this point you must filter your data by inputting a snapshot definition. To do so, first select the Filter Snapshots button.
This step refines the results of your query. Here are a few examples of snapshot definitions.
The following elements may be used within the snapshot definition:
- dorisViews - the required root element to begin a snapshot definition.
- view - the required name of the view/table used within your Argos query.
- entity - the required name of the entity from within DORIS.
- tags - this is a user-defined key-word(s) created to identify a snapshot for surveys or other purposes. Specifying tags within the snapshot definition filter can help to further narrow the snapshots returned within a result set. Note that the use of multiple tags must be enclosed in brackets.
- startDate - the beginning date of the desired snapshot range. This date must be in the "yyyy-MM-dd" format.
- endDate - the end date of the desired snapshot range. This date must be in the "yyyy-MM-dd" format.
Variables can be used for values within the snapshot definition. They can be free-typed or inserted by selecting the user-defined variable icon to display a list of System Variables that can be added to your snapshot definition.
Validate and test the query to ensure that you are getting back the expected results:
